TIME Columns

HOUR(<column>) - returns the hours part of each record's time

MINUTE(<column>) - returns the minutes part of each record

SECOND(<column>) - return the seconds part of each record

Hours are returned in 24-hour format. For example: given a table of bank transactions, to find all the transactions that took place between 9am and 3pm use the following:

Special function for Text columns containing US zip codes/UK post code fields:

PAREA(<column>) - returns the Postal Area code for each record.

PDIST(<column>) - returns the Postal District code for each record.

SORTFORMAT(<column>) - converts the postcode to Sort Format.

• NSQL Functions Overview
  • NSQL Functions A to Z
  • NSQL Intrinsic Functions
  • DATE Columns
  • Distance Calculations
  • Miscellaneous Functions
  • NUMERIC Columns
  • Text Columns
  • TIME Columns